<?php 
class CartWS_Model_TaxRate extends Ext_Db_Table
{
	protected $_name = 'sc_tax_rate';
	protected $_sequence = 'sc_tax_rate_seq';
	public function getSelectWithDescr()
	{
		return $this->getAdapter()->select()
			->from( array( 'tr' => 'sc_tax_rate' ), 
				array( 'tr.*', 'fend_date' => "to_char( tr.end_date, '". self::DEFAULT_DATE_FORMAT. "')" ))
			->join( 
				array( 'tc' => 'sc_tax_class' )
				, 'tr.tax_class_id = tc.tax_class_id'
				, array( 'tc.title' ) 
			);
	}
}